CREATE TABLE test (
  _id INTEGER NOT NULL PRIMARY KEY,
  date1 TEXT NOT NULL DEFAULT LOCALTIME(2),
  date2 TEXT NOT NULL DEFAULT LOCALTIMESTAMP(3)
);

UPDATE test
SET date1 = LOCALTIME(6),
    date2 = LOCALTIMESTAMP(2);

UPDATE test
SET date1 = LOCALTIME(2),
    date2 = LOCALTIMESTAMP(3)
WHERE date1 > LOCALTIME(1);
